﻿CREATE TABLE [dbo].[UsersAuthentication] (
    [Id]       UNIQUEIDENTIFIER NOT NULL,
    [Name]     NVARCHAR (50)    NOT NULL,
    [Email]    NVARCHAR (255)   NOT NULL,
    [Password] NVARCHAR (100)   NOT NULL,
    [Roles]    NVARCHAR (50)    NOT NULL,
    [IsActive] BIT              NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    UNIQUE NONCLUSTERED ([Email] ASC)
);

